drop table board;

create table board(
	board_no number primary key,
	title varchar2(100) not null,
	content varchar2(2000) not null,
	w_date date not null,
	count number not null,
	category varchar2(20) not null,
	m_uid number not null,
	constraint fk_board_id foreign key(m_uid) references member(m_uid)
);

drop sequence board_seq;
create sequence board_seq nocache;

insert into board(board_no,title,content,w_date,count,category,m_uid) values(board_seq.nextval,'으히히히','첫글이다~',sysdate,0,'free',2);
insert into board(board_no,title,content,w_date,count,category,m_uid) values(board_seq.nextval,'asd','aaa',sysdate,0,'free',3);
insert into board(board_no,title,content,w_date,count,category,m_uid) values(board_seq.nextval,'sdf','!!!~',sysdate,0,'free',3);
insert into board(board_no,title,content,w_date,count,category,m_uid) values(board_seq.nextval,'qwe','으히히',sysdate,0,'tip',5);
insert into board(board_no,title,content,w_date,count,category,m_uid) values(board_seq.nextval,'sdf','으히히~',sysdate,0,'free',5);
insert into board(board_no,title,content,w_date,count,category,m_uid) values(board_seq.nextval,'xcv','으히히~',sysdate,0,'free',6);
insert into board(board_no,title,content,w_date,count,category,m_uid) values(board_seq.nextval,'wer','으히히~',sysdate,0,'free',7);
insert into board(board_no,title,content,w_date,count,category,m_uid) values(board_seq.nextval,'cvb','으히히~',sysdate,0,'free',3);
insert into board(board_no,title,content,w_date,count,category,m_uid) values(board_seq.nextval,'sdf','으히히~',sysdate,0,'free',2);
insert into board(board_no,title,content,w_date,count,category,m_uid) values(board_seq.nextval,'wer','으히히~',sysdate,0,'tip',2);
insert into board(board_no,title,content,w_date,count,category,m_uid) values(board_seq.nextval,'sdf','으히히~',sysdate,0,'tip',3);
insert into board(board_no,title,content,w_date,count,category,m_uid) values(board_seq.nextval,'sdf','으히히~',sysdate,0,'tip',4);
insert into board(board_no,title,content,w_date,count,category,m_uid) values(board_seq.nextval,'qwqe','으히히~',sysdate,0,'tip',4);
insert into board(board_no,title,content,w_date,count,category,m_uid) values(board_seq.nextval,'dg','으히히~',sysdate,0,'tip',2);
insert into board(board_no,title,content,w_date,count,category,m_uid) values(board_seq.nextval,'cvb','으히히~',sysdate,0,'free',5);
insert into board(board_no,title,content,w_date,count,category,m_uid) values(board_seq.nextval,'sdf','으히히~',sysdate,0,'free',6);
insert into board(board_no,title,content,w_date,count,category,m_uid) values(board_seq.nextval,'wer','으히히~',sysdate,0,'tip',7);
insert into board(board_no,title,content,w_date,count,category,m_uid) values(board_seq.nextval,'cvb','으히히~',sysdate,0,'free',4);
insert into board(board_no,title,content,w_date,count,category,m_uid) values(board_seq.nextval,'dfg','으히히~',sysdate,0,'free',3);
insert into board(board_no,title,content,w_date,count,category,m_uid) values(board_seq.nextval,'wer','으히히~',sysdate,0,'tip',4);
insert into board(board_no,title,content,w_date,count,category,m_uid) values(board_seq.nextval,'dfg','으히히~',sysdate,0,'free',2);


select * from board;













